Refreshing web report data

When a report contains saved data, the report does not need to access a database. It retrieves the information directly from the Web Component Server. This can greatly reduce network traffic and the use of network server resources when many people are frequently requesting reports. For this reason, you may want to design most of your reports so that they contain saved data. Additionally, reports containing saved data can be easily cached by the Web Component Server for optimized job sharing, serving more users with the same information simultaneously. However, if a report contains saved data, and changes are made in the original database, the report will not reflect accurate information. To update the report, you can open it in Seagate Crystal Reports, refresh the data, and save the report again. However, the Web Component Server also provides a means to dynamically refresh report data.

As a web system administrator, you must decide if you want to allow users to refresh report data themselves, or if you want to control how and how often they can refresh report data. Each of the Report Viewers include a button to refresh the data while it is viewed. However, sites with several users refreshing report data can result in network and system slow downs since every refresh requires connecting to a database and gathering data.

You can override or even disable the user's capability for refreshing and create other means for keeping up-to-date data in reports. One method is to set automatic refreshes using the Database Refresh setting in the Page Server tab of the Crystal Report Web Components Manager application. For more information, see Database Refresh.

When deciding how data will be refreshed at your web site, keep in mind that frequent refreshes of report data limits report caching capabilities of the Web Component Server. Every time the report is refreshed, any cached version of that report becomes obsolete.



Seagate Software, Inc.
http://www.seagatesoftware.com
Please send comments to:
techpubs@seagatesoftware.com